home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
vallevents.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
746b
|
23 lines
/*
Collects the Events information from the component sub-views...
Set up this way because of the limitations on the size of a view.
The Date in the WHERE clause is to reduce the quantity
of data returned, and may be adjusted from time to time as desired;
be aware that this limits the dates for which the report can be run.
*/
create or replace view vallevents as
select * from veventsPart1
where trunc(conv_date) > '30-SEP-1999'
union
select * from veventsPart2
where trunc(conv_date) > '30-SEP-1999'
union
select * from veventsPart3
where trunc(conv_date) > '30-SEP-1999'
union
select * from veventsPart4
where trunc(conv_date) > '30-SEP-1999'
union
select * from veventsPart5
where trunc(conv_date) > '30-SEP-1999';